Pandas Profiling Report

Dataset statistics

Number of variables	43
Number of observations	2535791
Missing cells	62676385
Missing cells (%)	57.5%
Duplicate rows	238112
Duplicate rows (%)	9.4%
Total size in memory	831.9 MiB
Average record size in memory	344.0 B

Variable types

NUM	18
UNSUPPORTED	13
CAT	12

Warnings

Dataset has 238112 (9.4%) duplicate rows	Duplicates
`Date mutation` has a high cardinality: 361 distinct values	High cardinality
`Type de voie` has a high cardinality: 137 distinct values	High cardinality
`Code voie` has a high cardinality: 16233 distinct values	High cardinality
`Voie` has a high cardinality: 357364 distinct values	High cardinality
`Commune` has a high cardinality: 29380 distinct values	High cardinality
`Section` has a high cardinality: 583 distinct values	High cardinality
`Nature culture speciale` has a high cardinality: 118 distinct values	High cardinality
`5eme lot` is highly correlated with `4eme lot`	High correlation
`4eme lot` is highly correlated with `5eme lot`	High correlation
`Type local` is highly correlated with `Code type local`	High correlation
`Code type local` is highly correlated with `Type local`	High correlation
`Code service CH` has 2535791 (100.0%) missing values	Missing
`Reference document` has 2535791 (100.0%) missing values	Missing
`1 Articles CGI` has 2535791 (100.0%) missing values	Missing
`2 Articles CGI` has 2535791 (100.0%) missing values	Missing
`3 Articles CGI` has 2535791 (100.0%) missing values	Missing
`4 Articles CGI` has 2535791 (100.0%) missing values	Missing
`5 Articles CGI` has 2535791 (100.0%) missing values	Missing
`Valeur fonciere` has 29261 (1.2%) missing values	Missing
`No voie` has 1025638 (40.4%) missing values	Missing
`B/T/Q` has 2426362 (95.7%) missing values	Missing
`Type de voie` has 1053720 (41.6%) missing values	Missing
`Code voie` has 28189 (1.1%) missing values	Missing
`Voie` has 28354 (1.1%) missing values	Missing
`Code postal` has 28323 (1.1%) missing values	Missing
`Prefixe de section` has 2408956 (95.0%) missing values	Missing
`No Volume` has 2529165 (99.7%) missing values	Missing
`1er lot` has 1753172 (69.1%) missing values	Missing
`Surface Carrez du 1er lot` has 2314726 (91.3%) missing values	Missing
`2eme lot` has 2372713 (93.6%) missing values	Missing
`Surface Carrez du 2eme lot` has 2481517 (97.9%) missing values	Missing
`3eme lot` has 2509709 (99.0%) missing values	Missing
`Surface Carrez du 3eme lot` has 2530577 (99.8%) missing values	Missing
`4eme lot` has 2526555 (99.6%) missing values	Missing
`Surface Carrez du 4eme lot` has 2534376 (99.9%) missing values	Missing
`5eme lot` has 2531364 (99.8%) missing values	Missing
`Surface Carrez du 5eme lot` has 2535182 (> 99.9%) missing values	Missing
`Code type local` has 1182459 (46.6%) missing values	Missing
`Type local` has 1182459 (46.6%) missing values	Missing
`Identifiant local` has 2535791 (100.0%) missing values	Missing
`Surface reelle bati` has 1184176 (46.7%) missing values	Missing
`Nombre pieces principales` has 1184176 (46.7%) missing values	Missing
`Nature culture` has 792958 (31.3%) missing values	Missing
`Nature culture speciale` has 2422938 (95.5%) missing values	Missing
`Surface terrain` has 792958 (31.3%) missing values	Missing
`No disposition` is highly skewed (γ1 = 70.78417421)	Skewed
`Valeur fonciere` is highly skewed (γ1 = 50.14941634)	Skewed
`Surface Carrez du 1er lot` is highly skewed (γ1 = 41.61602856)	Skewed
`Surface Carrez du 2eme lot` is highly skewed (γ1 = 68.81132406)	Skewed
`Nombre de lots` is highly skewed (γ1 = 28.12730824)	Skewed
`Surface reelle bati` is highly skewed (γ1 = 188.7084892)	Skewed
`Surface terrain` is highly skewed (γ1 = 44.79390898)	Skewed
`Code service CH` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Reference document` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`1 Articles CGI` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`2 Articles CGI` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`3 Articles CGI` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`4 Articles CGI` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`5 Articles CGI` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Code departement` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`No Volume` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`1er lot` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`2eme lot` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`3eme lot` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Identifiant local` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Nombre de lots` has 1753172 (69.1%) zeros	Zeros
`Surface reelle bati` has 316200 (12.5%) zeros	Zeros
`Nombre pieces principales` has 406960 (16.0%) zeros	Zeros

Reproduction

Analysis started	2020-10-22 01:28:42.266443
Analysis finished	2020-10-22 01:47:41.254186
Duration	18 minutes and 58.99 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

Code service CH
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	2535791
Missing (%)	100.0%
Memory size	19.3 MiB

Reference document
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	2535791
Missing (%)	100.0%
Memory size	19.3 MiB

1 Articles CGI
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	2535791
Missing (%)	100.0%
Memory size	19.3 MiB

2 Articles CGI
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	2535791
Missing (%)	100.0%
Memory size	19.3 MiB

3 Articles CGI
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	2535791
Missing (%)	100.0%
Memory size	19.3 MiB

4 Articles CGI
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	2535791
Missing (%)	100.0%
Memory size	19.3 MiB

5 Articles CGI
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	2535791
Missing (%)	100.0%
Memory size	19.3 MiB

No disposition
Real number (ℝ_≥0)

SKEWED

Distinct	620
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.199535372
Minimum	1
Maximum	694
Zeros	0
Zeros (%)	0.0%
Memory size	19.3 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	694
Range	693
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	7.401536829
Coefficient of variation (CV)	6.170336451
Kurtosis	5363.725904
Mean	1.199535372
Median Absolute Deviation (MAD)	0
Skewness	70.78417421
Sum	3041771
Variance	54.78274742
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2390187	94.3%
2	120232	4.7%
3	16449	0.6%
4	2927	0.1%
5	1286	0.1%
6	928	< 0.1%
7	664	< 0.1%
10	340	< 0.1%
8	202	< 0.1%
9	179	< 0.1%
Other values (610)	2397	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2390187	94.3%
2	120232	4.7%
3	16449	0.6%
4	2927	0.1%
5	1286	0.1%

Value	Count	Frequency (%)
694	1	< 0.1%
693	1	< 0.1%
692	1	< 0.1%
691	1	< 0.1%
690	1	< 0.1%

Date mutation
Categorical

HIGH CARDINALITY

Distinct	361
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	19.3 MiB

29/03/2019	22208
28/06/2019	22165
29/05/2019	18948
28/02/2019	17537
30/04/2019	17332
Other values (356)	2437601

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
29/03/2019	22208	0.9%
28/06/2019	22165	0.9%
29/05/2019	18948	0.7%
28/02/2019	17537	0.7%
30/04/2019	17332	0.7%
31/01/2019	17126	0.7%
20/12/2019	16089	0.6%
15/03/2019	15716	0.6%
26/04/2019	15652	0.6%
28/05/2019	15360	0.6%
Other values (351)	2357658	93.0%

Frequencies of value counts

Unique

Unique	4 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Nature mutation
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	19.3 MiB

Vente	2308539
Vente en l'état futur d'achèvement	185441
Echange	27127
Vente terrain à bâtir	7806
Adjudication	4819

Frequencies
Length

Value	Count	Frequency (%)
Vente	2308539	91.0%
Vente en l'état futur d'achèvement	185441	7.3%
Echange	27127	1.1%
Vente terrain à bâtir	7806	0.3%
Adjudication	4819	0.2%
Expropriation	2059	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	34
Median length	5
Mean length	7.21120116
Min length	5

Valeur fonciere
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	108435
Distinct (%)	4.3%
Missing	29261
Missing (%)	1.2%
Infinite	0
Infinite (%)	0.0%

Mean	971597.0403
Minimum	0.01
Maximum	2086000000
Zeros	0
Zeros (%)	0.0%
Memory size	19.3 MiB

Quantile statistics

Minimum	0.01
5-th percentile	2700
Q1	60000
median	149000
Q3	269000
95-th percentile	1350000
Maximum	2086000000
Range	2086000000
Interquartile range (IQR)	209000

Descriptive statistics

Standard deviation	7856913.856
Coefficient of variation (CV)	8.08659715
Kurtosis	7985.25884
Mean	971597.0403
Median Absolute Deviation (MAD)	99000
Skewness	50.14941634
Sum	2.435337129e+12
Variance	6.173109535e+13
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100000	21742	0.9%
150000	21157	0.8%
120000	19573	0.8%
80000	18482	0.7%
1	18101	0.7%
130000	17634	0.7%
110000	17424	0.7%
200000	17233	0.7%
50000	17153	0.7%
140000	17150	0.7%
Other values (108425)	2320881	91.5%
(Missing)	29261	1.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.01	2	< 0.1%
0.1	12	< 0.1%
0.15	123	< 0.1%
0.16	3	< 0.1%
0.18	7	< 0.1%

Value	Count	Frequency (%)
2086000000	2	< 0.1%
1750000000	3	< 0.1%
845000000	2	< 0.1%
690186750	24	< 0.1%
612990460	6	< 0.1%

No voie
Real number (ℝ_≥0)

MISSING

Distinct	6577
Distinct (%)	0.4%
Missing	1025638
Missing (%)	40.4%
Infinite	0
Infinite (%)	0.0%

Mean	727.0275005
Minimum	1
Maximum	9999
Zeros	0
Zeros (%)	0.0%
Memory size	19.3 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	24
Q3	87
95-th percentile	5633
Maximum	9999
Range	9998
Interquartile range (IQR)	79

Descriptive statistics

Standard deviation	2076.793685
Coefficient of variation (CV)	2.856554509
Kurtosis	8.223053939
Mean	727.0275005
Median Absolute Deviation (MAD)	20
Skewness	3.062480081
Sum	1097922761
Variance	4313072.01
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	67975	2.7%
2	60703	2.4%
4	48221	1.9%
3	48141	1.9%
5	43107	1.7%
6	42181	1.7%
7	37754	1.5%
8	37157	1.5%
9	34252	1.4%
10	34058	1.3%
Other values (6567)	1056604	41.7%
(Missing)	1025638	40.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	67975	2.7%
2	60703	2.4%
3	48141	1.9%
4	48221	1.9%
5	43107	1.7%

Value	Count	Frequency (%)
9999	261	< 0.1%
9998	67	< 0.1%
9997	11	< 0.1%
9996	15	< 0.1%
9995	15	< 0.1%

B/T/Q
Categorical

MISSING

Distinct	40
Distinct (%)	< 0.1%
Missing	2426362
Missing (%)	95.7%
Memory size	19.3 MiB

B	66043
A	16849
T	8914
F	8236
C	3187
Other values (35)	6200

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
B	66043	2.6%
A	16849	0.7%
T	8914	0.4%
F	8236	0.3%
C	3187	0.1%
D	1493	0.1%
Q	985	< 0.1%
E	890	< 0.1%
P	574	< 0.1%
G	395	< 0.1%
Other values (30)	1863	0.1%
(Missing)	2426362	95.7%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	2.913692414
Min length	1

Type de voie
Categorical

HIGH CARDINALITY
MISSING

Distinct	137
Distinct (%)	< 0.1%
Missing	1053720
Missing (%)	41.6%
Memory size	19.3 MiB

RUE	862542
AV	195932
RTE	72401
CHE	71983
BD	67221
Other values (132)	211992

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
RUE	862542	34.0%
AV	195932	7.7%
RTE	72401	2.9%
CHE	71983	2.8%
BD	67221	2.7%
ALL	48966	1.9%
IMP	35154	1.4%
PL	28781	1.1%
RES	19975	0.8%
QUAI	7859	0.3%
Other values (127)	71257	2.8%
(Missing)	1053720	41.6%

Frequencies of value counts

Unique

Unique	9 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	4
Median length	3
Mean length	2.887699736
Min length	1

Code voie
Categorical

HIGH CARDINALITY
MISSING

Distinct	16233
Distinct (%)	0.6%
Missing	28189
Missing (%)	1.1%
Memory size	19.3 MiB

0020	11086
B005	11070
0040	10652
B007	10557
0060	10434
Other values (16228)	2453803

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0020	11086	0.4%
B005	11070	0.4%
0040	10652	0.4%
B007	10557	0.4%
0060	10434	0.4%
B003	10426	0.4%
B006	10299	0.4%
B008	10292	0.4%
B016	10287	0.4%
B002	10204	0.4%
Other values (16223)	2402295	94.7%
(Missing)	28189	1.1%

Frequencies of value counts

Unique

Unique	1603 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	4
Median length	4
Mean length	3.988883548
Min length	3

Voie
Categorical

HIGH CARDINALITY
MISSING

Distinct	357364
Distinct (%)	14.3%
Missing	28354
Missing (%)	1.1%
Memory size	19.3 MiB

LE VILLAGE	23596
LE BOURG	21852
JEAN JAURES	11542
DE LA REPUBLIQUE	11186
VICTOR HUGO	7845
Other values (357359)	2431416

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
LE VILLAGE	23596	0.9%
LE BOURG	21852	0.9%
JEAN JAURES	11542	0.5%
DE LA REPUBLIQUE	11186	0.4%
VICTOR HUGO	7845	0.3%
GRANDE RUE	6721	0.3%
PASTEUR	6683	0.3%
DE PARIS	6031	0.2%
DE LA GARE	5966	0.2%
DE LA LIBERATION	5750	0.2%
Other values (357354)	2400265	94.7%
(Missing)	28354	1.1%

Frequencies of value counts

Unique

Unique	126168 ?
Unique (%)	5.0%

Histogram of lengths of the category

Length

Max length	26
Median length	12
Mean length	12.46227745
Min length	1

Code postal
Real number (ℝ_≥0)

MISSING

Distinct	5797
Distinct (%)	0.2%
Missing	28323
Missing (%)	1.1%
Infinite	0
Infinite (%)	0.0%

Mean	51976.36947
Minimum	1000
Maximum	97490
Zeros	0
Zeros (%)	0.0%
Memory size	19.3 MiB

Quantile statistics

Minimum	1000
5-th percentile	7100
Q1	31230
median	50200
Q3	77144
95-th percentile	93300
Maximum	97490
Range	96490
Interquartile range (IQR)	45914

Descriptive statistics

Standard deviation	27302.60504
Coefficient of variation (CV)	0.5252888056
Kurtosis	-1.156558117
Mean	51976.36947
Median Absolute Deviation (MAD)	24100
Skewness	-0.04981286052
Sum	1.303290832e+11
Variance	745432242.1
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18000	7526	0.3%
51100	6844	0.3%
75015	6582	0.3%
75018	6411	0.3%
75016	6390	0.3%
76600	6056	0.2%
75017	5574	0.2%
44300	5416	0.2%
6000	5324	0.2%
44000	5114	0.2%
Other values (5787)	2446231	96.5%
(Missing)	28323	1.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1000	1040	< 0.1%
1090	210	< 0.1%
1100	888	< 0.1%
1110	592	< 0.1%
1120	299	< 0.1%

Value	Count	Frequency (%)
97490	199	< 0.1%
97480	293	< 0.1%
97470	16	< 0.1%
97460	40	< 0.1%
97450	115	< 0.1%

Commune
Categorical

HIGH CARDINALITY

Distinct	29380
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Memory size	19.3 MiB

TOULOUSE	18045
NANTES	16576
NICE	15415
BORDEAUX	13463
LILLE	11705
Other values (29375)	2460587

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
TOULOUSE	18045	0.7%
NANTES	16576	0.7%
NICE	15415	0.6%
BORDEAUX	13463	0.5%
LILLE	11705	0.5%
NIMES	8881	0.4%
LE HAVRE	8860	0.3%
ANGERS	8054	0.3%
SAINT-ETIENNE	7593	0.3%
BOURGES	7522	0.3%
Other values (29370)	2419677	95.4%

Frequencies of value counts

Unique

Unique	789 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	30
Median length	9
Mean length	11.41841264
Min length	1

Code departement
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	19.3 MiB

Code commune
Real number (ℝ_≥0)

Distinct	908
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	208.9969296
Minimum	1
Maximum	909
Zeros	0
Zeros (%)	0.0%
Memory size	19.3 MiB

Quantile statistics

Minimum	1
5-th percentile	13
Q1	76
median	174
Q3	300
95-th percentile	555
Maximum	909
Range	908
Interquartile range (IQR)	224

Descriptive statistics

Standard deviation	167.0736643
Coefficient of variation (CV)	0.7994072674
Kurtosis	0.5673820201
Mean	208.9969296
Median Absolute Deviation (MAD)	108
Skewness	1.013132693
Sum	529972533
Variance	27913.60932
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
63	25360	1.0%
109	23331	0.9%
88	20827	0.8%
555	19687	0.8%
7	18192	0.7%
4	17826	0.7%
33	15374	0.6%
218	15197	0.6%
194	14694	0.6%
1	14273	0.6%
Other values (898)	2351030	92.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	14273	0.6%
2	9988	0.4%
3	11313	0.4%
4	17826	0.7%
5	11495	0.5%

Value	Count	Frequency (%)
909	10	< 0.1%
908	55	< 0.1%
907	46	< 0.1%
906	51	< 0.1%
905	35	< 0.1%

Prefixe de section
Real number (ℝ_≥0)

MISSING

Distinct	710
Distinct (%)	0.6%
Missing	2408956
Missing (%)	95.0%
Infinite	0
Infinite (%)	0.0%

Mean	459.4845744
Minimum	1
Maximum	950
Zeros	0
Zeros (%)	0.0%
Memory size	19.3 MiB

Quantile statistics

Minimum	1
5-th percentile	40
Q1	166
median	331
Q3	829
95-th percentile	880
Maximum	950
Range	949
Interquartile range (IQR)	663

Descriptive statistics

Standard deviation	326.0986731
Coefficient of variation (CV)	0.709705377
Kurtosis	-1.699463289
Mean	459.4845744
Median Absolute Deviation (MAD)	265
Skewness	0.1634567861
Sum	58278726
Variance	106340.3446
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
166	2005	0.1%
830	1621	0.1%
831	1471	0.1%
844	1431	0.1%
839	1289	0.1%
828	1258	< 0.1%
842	1241	< 0.1%
177	1160	< 0.1%
843	1088	< 0.1%
841	1034	< 0.1%
Other values (700)	113237	4.5%
(Missing)	2408956	95.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	139	< 0.1%
2	106	< 0.1%
3	42	< 0.1%
4	496	< 0.1%
5	67	< 0.1%

Value	Count	Frequency (%)
950	158	< 0.1%
911	145	< 0.1%
910	247	< 0.1%
909	38	< 0.1%
908	165	< 0.1%

Section
Categorical

HIGH CARDINALITY

Distinct	583
Distinct (%)	< 0.1%
Missing	74
Missing (%)	< 0.1%
Memory size	19.3 MiB

A	182703
B	174753
C	121195
AB	106184
AC	85653
Other values (578)	1865229

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
A	182703	7.2%
B	174753	6.9%
C	121195	4.8%
AB	106184	4.2%
AC	85653	3.4%
D	83017	3.3%
AD	74002	2.9%
AE	66990	2.6%
AH	61627	2.4%
AI	58718	2.3%
Other values (573)	1520875	60.0%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	2
Mean length	1.691832253
Min length	1

No plan
Real number (ℝ_≥0)

Distinct	6356
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	403.7908471
Minimum	1
Maximum	9762
Zeros	0
Zeros (%)	0.0%
Memory size	19.3 MiB

Quantile statistics

Minimum	1
5-th percentile	15
Q1	87
median	223
Q3	504
95-th percentile	1374
Maximum	9762
Range	9761
Interquartile range (IQR)	417

Descriptive statistics

Standard deviation	554.6664385
Coefficient of variation (CV)	1.373647874
Kurtosis	27.45317251
Mean	403.7908471
Median Absolute Deviation (MAD)	166
Skewness	4.053965317
Sum	1023929196
Variance	307654.858
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	10597	0.4%
5	9458	0.4%
3	9403	0.4%
7	9309	0.4%
19	9091	0.4%
22	8957	0.4%
2	8889	0.4%
6	8850	0.3%
4	8811	0.3%
15	8619	0.3%
Other values (6346)	2443807	96.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	10597	0.4%
2	8889	0.4%
3	9403	0.4%
4	8811	0.3%
5	9458	0.4%

Value	Count	Frequency (%)
9762	1	< 0.1%
9759	1	< 0.1%
9757	1	< 0.1%
9731	1	< 0.1%
9730	1	< 0.1%

No Volume
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	2529165
Missing (%)	99.7%
Memory size	19.3 MiB

1er lot
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1753172
Missing (%)	69.1%
Memory size	19.3 MiB

Surface Carrez du 1er lot
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	17117
Distinct (%)	7.7%
Missing	2314726
Missing (%)	91.3%
Infinite	0
Infinite (%)	0.0%

Mean	60.97691502
Minimum	0.14
Maximum	9646.2
Zeros	0
Zeros (%)	0.0%
Memory size	19.3 MiB

Quantile statistics

Minimum	0.14
5-th percentile	16.04
Q1	33.7
median	52.9
Q3	72.67
95-th percentile	116.15
Maximum	9646.2
Range	9646.06
Interquartile range (IQR)	38.97

Descriptive statistics

Standard deviation	91.91765768
Coefficient of variation (CV)	1.507417318
Kurtosis	2886.916952
Mean	60.97691502
Median Absolute Deviation (MAD)	19.45
Skewness	41.61602856
Sum	13479861.72
Variance	8448.855793
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12.5	897	< 0.1%
12	449	< 0.1%
15	270	< 0.1%
10	250	< 0.1%
13	245	< 0.1%
30	223	< 0.1%
40	203	< 0.1%
50	192	< 0.1%
25	190	< 0.1%
20	188	< 0.1%
Other values (17107)	217958	8.6%
(Missing)	2314726	91.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.14	1	< 0.1%
0.26	1	< 0.1%
0.36	1	< 0.1%
0.5	1	< 0.1%
0.61	1	< 0.1%

Value	Count	Frequency (%)
9646.2	1	< 0.1%
9101	1	< 0.1%
8946	1	< 0.1%
8719.9	1	< 0.1%
7634	1	< 0.1%

2eme lot
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	2372713
Missing (%)	93.6%
Memory size	19.3 MiB

Surface Carrez du 2eme lot
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	11544
Distinct (%)	21.3%
Missing	2481517
Missing (%)	97.9%
Infinite	0
Infinite (%)	0.0%

Mean	63.39926945
Minimum	0.13
Maximum	8630
Zeros	0
Zeros (%)	0.0%
Memory size	19.3 MiB

Quantile statistics

Minimum	0.13
5-th percentile	23.1865
Q1	42.75
median	60.6
Q3	76.04
95-th percentile	110.2835
Maximum	8630
Range	8629.87
Interquartile range (IQR)	33.29

Descriptive statistics

Standard deviation	58.86704493
Coefficient of variation (CV)	0.9285129852
Kurtosis	8774.357642
Mean	63.39926945
Median Absolute Deviation (MAD)	16.76
Skewness	68.81132406
Sum	3440931.95
Variance	3465.328979
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
69.16	103	< 0.1%
20.43	70	< 0.1%
55	46	< 0.1%
50	42	< 0.1%
67	41	< 0.1%
65	39	< 0.1%
54	39	< 0.1%
28	38	< 0.1%
60	37	< 0.1%
63	35	< 0.1%
Other values (11534)	53784	2.1%
(Missing)	2481517	97.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.13	1	< 0.1%
0.3	1	< 0.1%
0.54	1	< 0.1%
0.58	1	< 0.1%
0.63	1	< 0.1%

Value	Count	Frequency (%)
8630	1	< 0.1%
3583.64	1	< 0.1%
3006.59	1	< 0.1%
2520	1	< 0.1%
2111.68	1	< 0.1%

3eme lot
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	2509709
Missing (%)	99.0%
Memory size	19.3 MiB

Surface Carrez du 3eme lot
Real number (ℝ_≥0)

MISSING

Distinct	3961
Distinct (%)	76.0%
Missing	2530577
Missing (%)	99.8%
Infinite	0
Infinite (%)	0.0%

Mean	73.17790756
Minimum	0.85
Maximum	3583.64
Zeros	0
Zeros (%)	0.0%
Memory size	19.3 MiB

Quantile statistics

Minimum	0.85
5-th percentile	14
Q1	38.105
median	60.6
Q3	85.1875
95-th percentile	171.198
Maximum	3583.64
Range	3582.79
Interquartile range (IQR)	47.0825

Descriptive statistics

Standard deviation	90.46654054
Coefficient of variation (CV)	1.236254815
Kurtosis	537.2559044
Mean	73.17790756
Median Absolute Deviation (MAD)	23.28
Skewness	17.57419094
Sum	381549.61
Variance	8184.194957
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20.61	69	< 0.1%
195.18	21	< 0.1%
12.5	13	< 0.1%
15	12	< 0.1%
180.35	10	< 0.1%
20	9	< 0.1%
78	8	< 0.1%
29.9	7	< 0.1%
10	7	< 0.1%
1	7	< 0.1%
Other values (3951)	5051	0.2%
(Missing)	2530577	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.85	1	< 0.1%
1	7	< 0.1%
1.22	1	< 0.1%
1.25	1	< 0.1%
1.33	1	< 0.1%

Value	Count	Frequency (%)
3583.64	1	< 0.1%
2128.86	1	< 0.1%
1699.39	1	< 0.1%
1480.16	1	< 0.1%
1300	1	< 0.1%

4eme lot
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	688
Distinct (%)	7.4%
Missing	2526555
Missing (%)	99.6%
Infinite	0
Infinite (%)	0.0%

Mean	113.2001949
Minimum	2
Maximum	17014
Zeros	0
Zeros (%)	0.0%
Memory size	19.3 MiB

Quantile statistics

Minimum	2
5-th percentile	4
Q1	7
median	24
Q3	68
95-th percentile	349
Maximum	17014
Range	17012
Interquartile range (IQR)	61

Descriptive statistics

Standard deviation	523.0737147
Coefficient of variation (CV)	4.620784577
Kurtosis	300.8019752
Mean	113.2001949
Median Absolute Deviation (MAD)	19
Skewness	14.89310183
Sum	1045517
Variance	273606.111
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	575	< 0.1%
8	520	< 0.1%
7	505	< 0.1%
6	482	< 0.1%
4	463	< 0.1%
5	463	< 0.1%
3	230	< 0.1%
2	185	< 0.1%
13	147	< 0.1%
17	109	< 0.1%
Other values (678)	5557	0.2%
(Missing)	2526555	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	185	< 0.1%
3	230	< 0.1%
4	463	< 0.1%
5	463	< 0.1%
6	482	< 0.1%

Value	Count	Frequency (%)
17014	1	< 0.1%
11279	1	< 0.1%
11045	1	< 0.1%
11043	1	< 0.1%
11041	1	< 0.1%

Surface Carrez du 4eme lot
Real number (ℝ_≥0)

MISSING

Distinct	1174
Distinct (%)	83.0%
Missing	2534376
Missing (%)	99.9%
Infinite	0
Infinite (%)	0.0%

Mean	86.96414841
Minimum	1
Maximum	3208.9
Zeros	0
Zeros (%)	0.0%
Memory size	19.3 MiB

Quantile statistics

Minimum	1
5-th percentile	10.528
Q1	30.51
median	61.9
Q3	100.275
95-th percentile	220.733
Maximum	3208.9
Range	3207.9
Interquartile range (IQR)	69.765

Descriptive statistics

Standard deviation	146.2351366
Coefficient of variation (CV)	1.681556587
Kurtosis	192.7926595
Mean	86.96414841
Median Absolute Deviation (MAD)	34.76
Skewness	11.58141302
Sum	123054.27
Variance	21384.71518
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20.99	68	< 0.1%
115.75	21	< 0.1%
53.93	8	< 0.1%
12.5	7	< 0.1%
20	6	< 0.1%
11.52	4	< 0.1%
49	4	< 0.1%
88.6	4	< 0.1%
15.9	4	< 0.1%
72	4	< 0.1%
Other values (1164)	1285	0.1%
(Missing)	2534376	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	3	< 0.1%
1.55	1	< 0.1%
1.8	1	< 0.1%
2.33	1	< 0.1%
3.09	1	< 0.1%

Value	Count	Frequency (%)
3208.9	1	< 0.1%
2023	1	< 0.1%
1612	1	< 0.1%
1588.25	1	< 0.1%
1362.6	1	< 0.1%

5eme lot
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	480
Distinct (%)	10.8%
Missing	2531364
Missing (%)	99.8%
Infinite	0
Infinite (%)	0.0%

Mean	113.9613734
Minimum	2
Maximum	11046
Zeros	0
Zeros (%)	0.0%
Memory size	19.3 MiB

Quantile statistics

Minimum	2
5-th percentile	4
Q1	8
median	27
Q3	73
95-th percentile	359
Maximum	11046
Range	11044
Interquartile range (IQR)	65

Descriptive statistics

Standard deviation	452.971562
Coefficient of variation (CV)	3.974781529
Kurtosis	170.5934583
Mean	113.9613734
Median Absolute Deviation (MAD)	21
Skewness	11.41445096
Sum	504507
Variance	205183.236
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	271	< 0.1%
8	261	< 0.1%
5	238	< 0.1%
6	228	< 0.1%
7	221	< 0.1%
4	132	< 0.1%
3	114	< 0.1%
14	88	< 0.1%
63	76	< 0.1%
93	76	< 0.1%
Other values (470)	2722	0.1%
(Missing)	2531364	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	55	< 0.1%
3	114	< 0.1%
4	132	< 0.1%
5	238	< 0.1%
6	228	< 0.1%

Value	Count	Frequency (%)
11046	1	< 0.1%
7036	2	< 0.1%
7005	1	< 0.1%
6175	1	< 0.1%
6074	1	< 0.1%

Surface Carrez du 5eme lot
Real number (ℝ_≥0)

MISSING

Distinct	473
Distinct (%)	77.7%
Missing	2535182
Missing (%)	> 99.9%
Infinite	0
Infinite (%)	0.0%

Mean	94.38018062
Minimum	0.89
Maximum	1029.55
Zeros	0
Zeros (%)	0.0%
Memory size	19.3 MiB

Quantile statistics

Minimum	0.89
5-th percentile	11.02
Q1	23.79
median	65
Q3	116.1
95-th percentile	289.784
Maximum	1029.55
Range	1028.66
Interquartile range (IQR)	92.31

Descriptive statistics

Standard deviation	113.2562445
Coefficient of variation (CV)	1.200000294
Kurtosis	15.35982861
Mean	94.38018062
Median Absolute Deviation (MAD)	41.21
Skewness	3.299525784
Sum	57477.53
Variance	12826.97691
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23.79	68	< 0.1%
116.1	21	< 0.1%
34.84	7	< 0.1%
12.5	5	< 0.1%
11.02	4	< 0.1%
41.67	4	< 0.1%
21.1	4	< 0.1%
139.96	3	< 0.1%
19	3	< 0.1%
55.1	3	< 0.1%
Other values (463)	487	< 0.1%
(Missing)	2535182	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.89	1	< 0.1%
0.97	1	< 0.1%
2	1	< 0.1%
2.08	1	< 0.1%
2.23	1	< 0.1%

Value	Count	Frequency (%)
1029.55	1	< 0.1%
818.8	1	< 0.1%
671.9	1	< 0.1%
662.35	1	< 0.1%
635.69	1	< 0.1%

Nombre de lots
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	75
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.3943329714
Minimum	0
Maximum	175
Zeros	1753172
Zeros (%)	69.1%
Memory size	19.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	175
Range	175
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.8086630828
Coefficient of variation (CV)	2.050711306
Kurtosis	3551.225082
Mean	0.3943329714
Median Absolute Deviation (MAD)	0
Skewness	28.12730824
Sum	999946
Variance	0.6539359815
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1753172	69.1%
1	619541	24.4%
2	136996	5.4%
3	16846	0.7%
4	4809	0.2%
5	1831	0.1%
6	887	< 0.1%
7	484	< 0.1%
8	296	< 0.1%
9	197	< 0.1%
Other values (65)	732	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1753172	69.1%
1	619541	24.4%
2	136996	5.4%
3	16846	0.7%
4	4809	0.2%

Value	Count	Frequency (%)
175	1	< 0.1%
159	1	< 0.1%
142	1	< 0.1%
141	1	< 0.1%
114	1	< 0.1%

Code type local
Categorical

HIGH CORRELATION
MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	1182459
Missing (%)	46.6%
Memory size	19.3 MiB

1	515398
2	430975
3	312480
4	94479

Frequencies
Length

Value	Count	Frequency (%)
1	515398	20.3%
2	430975	17.0%
3	312480	12.3%
4	94479	3.7%
(Missing)	1182459	46.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Type local
Categorical

HIGH CORRELATION
MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	1182459
Missing (%)	46.6%
Memory size	19.3 MiB

Maison	515398
Appartement	430975
Dépendance	312480
Local industriel. commercial ou assimilé	94479

Frequencies
Length

Value	Count	Frequency (%)
Maison	515398	20.3%
Appartement	430975	17.0%
Dépendance	312480	12.3%
Local industriel. commercial ou assimilé	94479	3.7%
(Missing)	1182459	46.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	40
Median length	6
Mean length	7.21055087
Min length	3

Identifiant local
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	2535791
Missing (%)	100.0%
Memory size	19.3 MiB

Surface reelle bati
Real number (ℝ_≥0)

MISSING
SKEWED
ZEROS

Distinct	3879
Distinct (%)	0.3%
Missing	1184176
Missing (%)	46.7%
Infinite	0
Infinite (%)	0.0%

Mean	87.75654014
Minimum	0
Maximum	312962
Zeros	316200
Zeros (%)	12.5%
Memory size	19.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	15
median	60
Q3	94
95-th percentile	170
Maximum	312962
Range	312962
Interquartile range (IQR)	79

Descriptive statistics

Standard deviation	872.8312276
Coefficient of variation (CV)	9.946053323
Kurtosis	49915.91499
Mean	87.75654014
Median Absolute Deviation (MAD)	38
Skewness	188.7084892
Sum	118613056
Variance	761834.352
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	316200	12.5%
80	20159	0.8%
60	18734	0.7%
90	18209	0.7%
70	18207	0.7%
50	15590	0.6%
100	15582	0.6%
65	14476	0.6%
40	13615	0.5%
75	12640	0.5%
Other values (3869)	888203	35.0%
(Missing)	1184176	46.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	316200	12.5%
1	271	< 0.1%
2	224	< 0.1%
3	277	< 0.1%
4	155	< 0.1%

Value	Count	Frequency (%)
312962	2	< 0.1%
240000	2	< 0.1%
215000	2	< 0.1%
212120	2	< 0.1%
152856	6	< 0.1%

Nombre pieces principales
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	40
Distinct (%)	< 0.1%
Missing	1184176
Missing (%)	46.7%
Infinite	0
Infinite (%)	0.0%

Mean	2.430351099
Minimum	0
Maximum	67
Zeros	406960
Zeros (%)	16.0%
Memory size	19.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3
Q3	4
95-th percentile	6
Maximum	67
Range	67
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.083948134
Coefficient of variation (CV)	0.8574679334
Kurtosis	2.659994281
Mean	2.430351099
Median Absolute Deviation (MAD)	2
Skewness	0.574144641
Sum	3284899
Variance	4.342839825
Monotocity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
0	406960	16.0%
4	229862	9.1%
3	225033	8.9%
2	164043	6.5%
5	137582	5.4%
1	102128	4.0%
6	53844	2.1%
7	19718	0.8%
8	7268	0.3%
9	2716	0.1%
Other values (30)	2461	0.1%
(Missing)	1184176	46.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	406960	16.0%
1	102128	4.0%
2	164043	6.5%
3	225033	8.9%
4	229862	9.1%

Value	Count	Frequency (%)
67	1	< 0.1%
56	1	< 0.1%
54	1	< 0.1%
53	2	< 0.1%
50	2	< 0.1%

Nature culture
Categorical

MISSING

Distinct	27
Distinct (%)	< 0.1%
Missing	792958
Missing (%)	31.3%
Memory size	19.3 MiB

S	839215
T	258358
P	130359
J	93845
AB	89648
Other values (22)	331408

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
S	839215	33.1%
T	258358	10.2%
P	130359	5.1%
J	93845	3.7%
AB	89648	3.5%
BT	74719	2.9%
L	63983	2.5%
AG	62807	2.5%
VI	29507	1.2%
BR	24929	1.0%
Other values (17)	75463	3.0%
(Missing)	792958	31.3%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.7599676
Min length	1

Nature culture speciale
Categorical

HIGH CARDINALITY
MISSING

Distinct	118
Distinct (%)	0.1%
Missing	2422938
Missing (%)	95.5%
Memory size	19.3 MiB

POTAG	27853
PIN	9982
PARC	9910
PATUR	9839
FRICH	6332
Other values (113)	48937

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
POTAG	27853	1.1%
PIN	9982	0.4%
PARC	9910	0.4%
PATUR	9839	0.4%
FRICH	6332	0.2%
VAOC	5177	0.2%
CHAT	3672	0.1%
IMM	3581	0.1%
CHENE	2651	0.1%
MARAI	2609	0.1%
Other values (108)	31247	1.2%
(Missing)	2422938	95.5%

Frequencies of value counts

Unique

Unique	5 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	5
Median length	3
Mean length	3.065863867
Min length	3

Surface terrain
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	41332
Distinct (%)	2.4%
Missing	792958
Missing (%)	31.3%
Infinite	0
Infinite (%)	0.0%

Mean	3092.532778
Minimum	0
Maximum	1662560
Zeros	59
Zeros (%)	< 0.1%
Memory size	19.3 MiB

Quantile statistics

Minimum	0
5-th percentile	30
Q1	233
median	610
Q3	1885
95-th percentile	12680
Maximum	1662560
Range	1662560
Interquartile range (IQR)	1652

Descriptive statistics

Standard deviation	13643.41327
Coefficient of variation (CV)	4.411727943
Kurtosis	3758.552168
Mean	3092.532778
Median Absolute Deviation (MAD)	486
Skewness	44.79390898
Sum	5389768179
Variance	186142725.7
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
500	33744	1.3%
1000	15348	0.6%
600	5037	0.2%
800	4922	0.2%
12	4329	0.2%
400	4212	0.2%
700	4106	0.2%
200	3942	0.2%
13	3936	0.2%
300	3915	0.2%
Other values (41322)	1659342	65.4%
(Missing)	792958	31.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	59	< 0.1%
1	3654	0.1%
2	3010	0.1%
3	2663	0.1%
4	2767	0.1%

Value	Count	Frequency (%)
1662560	1	< 0.1%
1420388	1	< 0.1%
1411524	7	< 0.1%
1335003	19	< 0.1%
1322177	33	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	Code service CH	Reference document	1 Articles CGI	2 Articles CGI	3 Articles CGI	4 Articles CGI	5 Articles CGI	No disposition	Date mutation	Nature mutation	Valeur fonciere	No voie	B/T/Q	Type de voie	Code voie	Voie	Code postal	Commune	Code departement	Code commune	Prefixe de section	Section	No plan	No Volume	1er lot	Surface Carrez du 1er lot	2eme lot	Surface Carrez du 2eme lot	3eme lot	Surface Carrez du 3eme lot	4eme lot	Surface Carrez du 4eme lot	5eme lot	Surface Carrez du 5eme lot	Nombre de lots	Code type local	Type local	Identifiant local	Surface reelle bati	Nombre pieces principales	Nature culture	Nature culture speciale	Surface terrain
0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	04/01/2019	Vente	37220.0	26.0	NaN	RUE	2730	DE MONTHOLON	1000.0	BOURG-EN-BRESSE	1	53	NaN	AI	298	NaN	8	19.27	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	2.0	Appartement	NaN	20.0	1.0	NaN	NaN	NaN
1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	04/01/2019	Vente	185100.0	22.0	NaN	RUE	1650	GEN DELESTRAINT	1000.0	BOURG-EN-BRESSE	1	53	NaN	AM	95	NaN	137	NaN	154	61.51	NaN	NaN	NaN	NaN	NaN	NaN	2	2.0	Appartement	NaN	62.0	3.0	NaN	NaN	NaN
2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	04/01/2019	Vente	185100.0	22.0	B	RUE	1650	GEN DELESTRAINT	1000.0	BOURG-EN-BRESSE	1	53	NaN	AM	95	NaN	7	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	3.0	Dépendance	NaN	0.0	0.0	NaN	NaN	NaN
3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	08/01/2019	Vente	209000.0	3.0	NaN	RUE	0043	DES CHAMPAGNES	1160.0	PRIAY	1	314	NaN	E	1676	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	1.0	Maison	NaN	90.0	4.0	S	NaN	940.0
4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	07/01/2019	Vente	134900.0	5.0	NaN	LOT	A003	LE BIOLAY	1370.0	SAINT-ETIENNE-DU-BOIS	1	350	NaN	AA	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	1.0	Maison	NaN	101.0	5.0	S	NaN	490.0
5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	03/01/2019	Vente	192000.0	165.0	NaN	ALL	0445	DES LIBELLULES	1340.0	ATTIGNAT	1	24	NaN	AI	94	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	1.0	Maison	NaN	88.0	4.0	S	NaN	708.0
6	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	08/01/2019	Vente	45000.0	9.0	NaN	RTE	0001	DU VIADUC	1250.0	CIZE	1	106	NaN	A	86	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	1.0	Maison	NaN	39.0	2.0	S	NaN	631.0
7	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	08/01/2019	Vente	45000.0	NaN	NaN	NaN	B017	SUR LA LATIE	1250.0	CIZE	1	106	NaN	A	975	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	NaN	NaN	NaN	NaN	NaN	L	NaN	120.0
8	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	04/01/2019	Vente	65000.0	50.0	NaN	RUE	1240	DOC NODET	1000.0	BOURG-EN-BRESSE	1	53	NaN	AL	3	NaN	317	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	3.0	Dépendance	NaN	0.0	0.0	NaN	NaN	NaN
9	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	04/01/2019	Vente	65000.0	50.0	NaN	RUE	1240	DOC NODET	1000.0	BOURG-EN-BRESSE	1	53	NaN	AL	3	NaN	17	NaN	33	67.78	NaN	NaN	NaN	NaN	NaN	NaN	2	2.0	Appartement	NaN	69.0	3.0	NaN	NaN	NaN

Last rows

	Code service CH	Reference document	1 Articles CGI	2 Articles CGI	3 Articles CGI	4 Articles CGI	5 Articles CGI	No disposition	Date mutation	Nature mutation	Valeur fonciere	No voie	B/T/Q	Type de voie	Code voie	Voie	Code postal	Commune	Code departement	Code commune	Prefixe de section	Section	No plan	No Volume	1er lot	Surface Carrez du 1er lot	2eme lot	Surface Carrez du 2eme lot	3eme lot	Surface Carrez du 3eme lot	4eme lot	Surface Carrez du 4eme lot	5eme lot	Surface Carrez du 5eme lot	Nombre de lots	Code type local	Type local	Identifiant local	Surface reelle bati	Nombre pieces principales	Nature culture	Nature culture speciale	Surface terrain
2535781	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	05/12/2019	Vente	17521000.0	32.0	NaN	QUAI	0940	DE BETHUNE	75004.0	PARIS 04	75	104	NaN	AU	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	3.0	Dépendance	NaN	0.0	0.0	S	NaN	470.0
2535782	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	05/12/2019	Vente	17521000.0	32.0	NaN	QUAI	0940	DE BETHUNE	75004.0	PARIS 04	75	104	NaN	AU	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	2.0	Appartement	NaN	70.0	3.0	S	NaN	470.0
2535783	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	05/12/2019	Vente	17521000.0	32.0	NaN	QUAI	0940	DE BETHUNE	75004.0	PARIS 04	75	104	NaN	AU	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	2.0	Appartement	NaN	47.0	1.0	S	NaN	470.0
2535784	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	05/12/2019	Vente	17521000.0	32.0	NaN	QUAI	0940	DE BETHUNE	75004.0	PARIS 04	75	104	NaN	AU	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	2.0	Appartement	NaN	55.0	2.0	S	NaN	470.0
2535785	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	05/12/2019	Vente	17521000.0	32.0	NaN	QUAI	0940	DE BETHUNE	75004.0	PARIS 04	75	104	NaN	AU	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	2.0	Appartement	NaN	66.0	4.0	S	NaN	470.0
2535786	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	05/12/2019	Vente	17521000.0	32.0	NaN	QUAI	0940	DE BETHUNE	75004.0	PARIS 04	75	104	NaN	AU	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	2.0	Appartement	NaN	120.0	5.0	S	NaN	470.0
2535787	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	05/12/2019	Vente	17521000.0	32.0	NaN	QUAI	0940	DE BETHUNE	75004.0	PARIS 04	75	104	NaN	AU	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	3.0	Dépendance	NaN	0.0	0.0	S	NaN	470.0
2535788	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	10/10/2019	Adjudication	610000.0	12.0	NaN	RUE	0797	BEAUTREILLIS	75004.0	PARIS 04	75	104	NaN	AQ	40	NaN	2	NaN	35	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	2.0	Appartement	NaN	44.0	2.0	NaN	NaN	NaN
2535789	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	30/12/2019	Vente	1400000.0	24.0	NaN	RUE	8752	SAINT SAUVEUR	75002.0	PARIS 02	75	102	NaN	AM	18	NaN	3	101.4	4	43.7	8	NaN	NaN	NaN	NaN	NaN	3	4.0	Local industriel. commercial ou assimilé	NaN	100.0	0.0	NaN	NaN	NaN
2535790	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	30/12/2019	Vente	1400000.0	24.0	NaN	RUE	8752	SAINT SAUVEUR	75002.0	PARIS 02	75	102	NaN	AM	18	NaN	10	43.7	14	55.4	NaN	NaN	NaN	NaN	NaN	NaN	2	2.0	Appartement	NaN	97.0	3.0	NaN	NaN	NaN

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows